{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select * from car_complain\")\n",
    "results = cursor.fetchall()\n",
    "car_complain = pd.DataFrame(results,columns=['id','brand','car_big','car_small','detail','question','time','condition','url','厂家','品牌','车系','车型'])\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "ly=car_complain[car_complain['car_big']=='朗逸']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>brand</th>\n",
       "      <th>car_big</th>\n",
       "      <th>car_small</th>\n",
       "      <th>detail</th>\n",
       "      <th>question</th>\n",
       "      <th>time</th>\n",
       "      <th>condition</th>\n",
       "      <th>url</th>\n",
       "      <th>厂家</th>\n",
       "      <th>品牌</th>\n",
       "      <th>车系</th>\n",
       "      <th>车型</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>99</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品雅版</td>\n",
       "      <td>购买上海大众朗逸欺骗车主实在可气</td>\n",
       "      <td>承诺不兑现,销售欺诈,</td>\n",
       "      <td>2010-05-04</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-05-04/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>160</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品雅版</td>\n",
       "      <td>订购上海大众朗逸承诺2个月到车但7个月后仍未提车</td>\n",
       "      <td>承诺不兑现,</td>\n",
       "      <td>2010-05-12</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-05-12/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>217</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>上海大众朗逸存在严重质量问题</td>\n",
       "      <td>制动系统,故障灯亮,</td>\n",
       "      <td>2010-05-19</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-05-19/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>222</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>上海大众朗逸车门异响严重扰人</td>\n",
       "      <td>车身附件及电器,门窗异响,</td>\n",
       "      <td>2010-05-20</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-05-20/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>410</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>上海大众朗逸倒车雷达坏了4S店售后服务极差</td>\n",
       "      <td>车身附件及电器,行车安全辅助系统故障,服务态度,</td>\n",
       "      <td>2010-06-10</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-06-10/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>530</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品轩版</td>\n",
       "      <td>朗逸仪表盘故障导致车辆无法启动</td>\n",
       "      <td>发动机,无法启动,</td>\n",
       "      <td>2010-06-24</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-06-24/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>576</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>朗逸刹车倒车时异响4S店推诿不保修</td>\n",
       "      <td>制动系统,异响,</td>\n",
       "      <td>2010-07-01</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-07-01/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>673</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.4T DSG 运动版</td>\n",
       "      <td>上海大众朗逸轮胎起包</td>\n",
       "      <td>轮胎,鼓包,</td>\n",
       "      <td>2010-07-15</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-07-15/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>714</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>大众朗逸平衡杆异响</td>\n",
       "      <td>转向系统,平衡杆故障,</td>\n",
       "      <td>2010-07-21</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-07-21/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>766</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>朗逸左边尾灯不严密、空调故障</td>\n",
       "      <td>车身附件及电器,空调问题,车身附件及电器,密封条损坏,</td>\n",
       "      <td>2010-07-27</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-07-27/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>813</th>\n",
       "      <td>927</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品轩版</td>\n",
       "      <td>上海大众朗逸摇窗机不到一年故障</td>\n",
       "      <td>车身附件及电器,车窗升降故障,</td>\n",
       "      <td>2010-08-18</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-08-18/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>967</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>上海大众朗逸车门异响严重！</td>\n",
       "      <td>车身附件及电器,门窗异响,</td>\n",
       "      <td>2010-08-23</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-08-23/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>1022</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>上海大众朗逸新车轮胎起包</td>\n",
       "      <td>轮胎,鼓包,</td>\n",
       "      <td>2010-08-29</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-08-29/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>1043</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品轩版</td>\n",
       "      <td>上海大众朗逸车门板等部位异响</td>\n",
       "      <td>车身附件及电器,门窗异响,</td>\n",
       "      <td>2010-08-31</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-08-31/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>1137</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>大众朗逸油耗表不准、内饰做工差、服务态度差</td>\n",
       "      <td>车身附件及电器,仪表故障,服务态度,</td>\n",
       "      <td>2010-09-10</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-09-10/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>1196</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>大众朗逸首保刚过出现异响</td>\n",
       "      <td>发动机,异响,</td>\n",
       "      <td>2010-09-15</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-09-15/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1086</th>\n",
       "      <td>1216</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>上海大众朗逸后挡玻璃漏水、后背箱漏水</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2010-09-17</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-09-17/20100...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1359</th>\n",
       "      <td>1508</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.6 手动 品雅版</td>\n",
       "      <td>上海大众朗逸新车100公里出现变速箱异响</td>\n",
       "      <td>变速器,异响,</td>\n",
       "      <td>2010-10-16</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-10-16/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1603</th>\n",
       "      <td>1765</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>上海大众朗逸后行李箱漏水</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2010-11-08</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-11-08/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>1824</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>世博版1.6 AT</td>\n",
       "      <td>上海大众朗逸发动机变速箱漏油</td>\n",
       "      <td>发动机,漏油,变速器,漏油,</td>\n",
       "      <td>2010-11-12</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-11-12/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1670</th>\n",
       "      <td>1834</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 2.0 自动 品尊版</td>\n",
       "      <td>上海大众朗逸音响无法正常使用</td>\n",
       "      <td>车身附件及电器,导航问题,</td>\n",
       "      <td>2010-11-15</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-11-15/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1900</th>\n",
       "      <td>2081</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>上海大众朗逸后行李箱漏水</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2010-12-09</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-12-09/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918</th>\n",
       "      <td>2102</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.6 手动 品雅版</td>\n",
       "      <td>大众朗逸品雅却一直提不到车说好的时间一拖再拖</td>\n",
       "      <td>承诺不兑现,</td>\n",
       "      <td>2010-12-11</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2010-12-11/20101...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2337</th>\n",
       "      <td>2533</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>大众朗逸车倒车异响严重</td>\n",
       "      <td>发动机,异响,</td>\n",
       "      <td>2011-02-10</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-02-10/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2509</th>\n",
       "      <td>2707</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.6 自动 品轩版</td>\n",
       "      <td>朗逸品轩行驶在不平路面时底盘异响</td>\n",
       "      <td>前后桥及悬挂系统,底盘异响,人员技术,</td>\n",
       "      <td>2011-02-24</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-02-24/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2853</th>\n",
       "      <td>3054</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.4T DSG 运动版</td>\n",
       "      <td>上海大众朗逸右前门异响4S店服务态度差</td>\n",
       "      <td>车身附件及电器,门窗异响,服务态度,</td>\n",
       "      <td>2011-03-21</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-03-21/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2952</th>\n",
       "      <td>3154</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI DSG 品雅版</td>\n",
       "      <td>上海大众朗逸高位刹车灯烧坏驾驶员座椅异响</td>\n",
       "      <td>车身附件及电器,座椅故障,服务态度,</td>\n",
       "      <td>2011-03-28</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-03-28/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>3178</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI DSG 品雅版</td>\n",
       "      <td>上海大众朗逸1.4TSI车发动机处漏水</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2011-03-29</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-03-29/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2977</th>\n",
       "      <td>3179</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI 手动 品轩版</td>\n",
       "      <td>上海大众朗逸车顶灯和车门异响严重</td>\n",
       "      <td>车身附件及电器,门窗异响,</td>\n",
       "      <td>2011-03-29</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-03-29/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2994</th>\n",
       "      <td>3198</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI DSG运动版</td>\n",
       "      <td>上海大众朗逸4S店欺瞒消费者逾期提不到车</td>\n",
       "      <td>销售欺诈,</td>\n",
       "      <td>2011-03-30</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/2011-03-30/20110...</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203001</th>\n",
       "      <td>289543</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸一键启动失效导致无法启动</td>\n",
       "      <td>发动机,无法启动,</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180709/289543....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203034</th>\n",
       "      <td>289592</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸发动机异响要求尽快解决</td>\n",
       "      <td>发动机,异响,</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180709/289592....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203124</th>\n",
       "      <td>289739</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2013款 1.6L 手动 舒适版</td>\n",
       "      <td>上汽大众朗逸天窗漏水气囊问题厂家未召回</td>\n",
       "      <td>车身附件及电器,天窗漏水,其他原因,厂家不召回,</td>\n",
       "      <td>2018-07-10</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180710/289739....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203180</th>\n",
       "      <td>289829</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸发动机舱起火整车自燃</td>\n",
       "      <td>车身附件及电器,车辆自燃,</td>\n",
       "      <td>2018-07-10</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180710/289829....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203299</th>\n",
       "      <td>289998</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸车内异味严重影响健康</td>\n",
       "      <td>车身附件及电器,车内异味,</td>\n",
       "      <td>2018-07-11</td>\n",
       "      <td>处理反馈</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180711/289998....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203399</th>\n",
       "      <td>290156</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2013款 1.6L 自动 风尚版 改款</td>\n",
       "      <td>上汽大众朗逸证件齐全4S店不予做首保</td>\n",
       "      <td>承诺不兑现,服务承诺不兑现,</td>\n",
       "      <td>2018-07-12</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180712/290156....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203467</th>\n",
       "      <td>290262</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸发动机严重积碳且加速异响</td>\n",
       "      <td>发动机,异响,发动机,抖动,</td>\n",
       "      <td>2018-07-12</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180712/290262....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203513</th>\n",
       "      <td>290336</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 230TSI 双离合 舒适版</td>\n",
       "      <td>上汽大众朗逸后尾灯进个苍蝇 4S店不给解决</td>\n",
       "      <td>车身附件及电器,车灯进水,</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180713/290336....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203525</th>\n",
       "      <td>290351</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.6 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸车身漏水严重要求尽快解决</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180713/290351....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203574</th>\n",
       "      <td>290419</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸两后车门漏水要求尽快解决</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2018-07-13</td>\n",
       "      <td>用户评分</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180713/290419....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203728</th>\n",
       "      <td>290682</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸踩离合或者刹车转速提高</td>\n",
       "      <td>发动机,怠速不稳,</td>\n",
       "      <td>2018-07-14</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180714/290682....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203739</th>\n",
       "      <td>290696</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 230TSI 双离合 舒适版</td>\n",
       "      <td>上汽大众朗逸变速箱异响 换挡困难 怠速过高</td>\n",
       "      <td>发动机,怠速不稳,变速器,异响,变速器,无法换挡,</td>\n",
       "      <td>2018-07-14</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180714/290696....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203746</th>\n",
       "      <td>290710</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2015款 230TSI DSG舒适版</td>\n",
       "      <td>上汽大众朗逸四条邓禄普轮胎有裂缝</td>\n",
       "      <td>轮胎,开裂,</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180715/290710....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203753</th>\n",
       "      <td>290721</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 风尚版</td>\n",
       "      <td>上汽大众朗逸发动机异响更换发动机后无效</td>\n",
       "      <td>发动机,异响,</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180715/290721....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203888</th>\n",
       "      <td>290907</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸4S店服务承诺不兑现维修技能差</td>\n",
       "      <td>人员技术,维修技术差,服务收费,变相收费,承诺不兑现,服务承诺不兑现,</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180715/290907....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203950</th>\n",
       "      <td>291006</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸车门漏水4S店不予妥善解决</td>\n",
       "      <td>车身附件及电器,车身漏水,服务态度,不解决问题,</td>\n",
       "      <td>2018-07-16</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180716/291006....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203994</th>\n",
       "      <td>291077</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 手动 风尚版</td>\n",
       "      <td>上汽大众朗逸车门及挡把异响希望尽快解决</td>\n",
       "      <td>变速器,挡把总成故障,车身附件及电器,门窗异响,</td>\n",
       "      <td>2018-07-16</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180716/291077....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204012</th>\n",
       "      <td>291108</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 手动 舒适版</td>\n",
       "      <td>上汽大众朗逸动力不足 变速箱抖动</td>\n",
       "      <td>发动机,功率不足,变速器,抖动,</td>\n",
       "      <td>2018-07-16</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180716/291108....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204146</th>\n",
       "      <td>291350</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2018款 1.5L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸经销商销售欺骗消费者</td>\n",
       "      <td>销售欺诈,与宣传不符,</td>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180717/291350....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204206</th>\n",
       "      <td>291459</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 手动 风尚版</td>\n",
       "      <td>上汽大众朗逸加装配件涉嫌欺骗消费者</td>\n",
       "      <td>服务收费,变相收费,销售欺诈,与宣传不符,</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180718/291459....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204235</th>\n",
       "      <td>291501</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2015款 1.6 手动 舒适版</td>\n",
       "      <td>上汽大众朗逸转向机故障售后不予质保</td>\n",
       "      <td>转向系统,转向机故障,</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180718/291501....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204500</th>\n",
       "      <td>291949</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2008款 1.6 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸两后车门漏水要求尽快解决</td>\n",
       "      <td>车身附件及电器,车身漏水,</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180720/291949....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204556</th>\n",
       "      <td>292026</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2015款 1.6L 自动 风尚版</td>\n",
       "      <td>上汽大众朗逸经销商销售承诺未兑现</td>\n",
       "      <td>承诺不兑现,销售承诺不兑现,</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180720/292026....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204624</th>\n",
       "      <td>292169</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.6 手动 品雅版</td>\n",
       "      <td>上汽大众朗逸刹车异响天窗漏水严重</td>\n",
       "      <td>制动系统,异响,车身附件及电器,天窗漏水,</td>\n",
       "      <td>2018-07-21</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180721/292169....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204706</th>\n",
       "      <td>292316</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸发动机舱起火整车自燃</td>\n",
       "      <td>车身附件及电器,车辆自燃,服务态度,不解决问题,</td>\n",
       "      <td>2018-07-22</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180722/292316....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204715</th>\n",
       "      <td>292327</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2011款 1.4TSI DSG品轩版</td>\n",
       "      <td>上汽大众朗逸变速箱阀体故障经常脱挡</td>\n",
       "      <td>变速器,滑阀箱故障,变速器,脱挡,</td>\n",
       "      <td>2018-07-22</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180722/292327....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204754</th>\n",
       "      <td>292396</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2014款 1.4TSI DSG蓝驱技术版</td>\n",
       "      <td>上汽大众朗逸DSG变速箱控制单元故障</td>\n",
       "      <td>变速器,滑阀箱故障,</td>\n",
       "      <td>2018-07-22</td>\n",
       "      <td>厂家受理</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180722/292396....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204883</th>\n",
       "      <td>292605</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 手动 舒适版</td>\n",
       "      <td>上汽大众朗逸下坡转弯时刹车经常失灵</td>\n",
       "      <td>制动系统,刹车失灵,</td>\n",
       "      <td>2018-07-23</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180723/292605....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204983</th>\n",
       "      <td>292783</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2017款 1.6L 自动 风尚版</td>\n",
       "      <td>上汽大众朗逸仪表显示油量数据错误</td>\n",
       "      <td>车身附件及电器,汽油泵故障,</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180724/292783....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204990</th>\n",
       "      <td>292803</td>\n",
       "      <td>上汽大众</td>\n",
       "      <td>朗逸</td>\n",
       "      <td>2015款 1.6L 自动 舒适版</td>\n",
       "      <td>上汽大众朗逸车购车一年变速箱部分漏油</td>\n",
       "      <td>变速器,漏油,</td>\n",
       "      <td>2018-07-24</td>\n",
       "      <td>信息审核</td>\n",
       "      <td>http://www.12365auto.com/zlts/20180724/292803....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2115 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id brand car_big              car_small                    detail  \\\n",
       "38          99  上汽大众      朗逸       2008款 1.6 自动 品雅版          购买上海大众朗逸欺骗车主实在可气   \n",
       "96         160  上汽大众      朗逸       2008款 1.6 手动 品雅版  订购上海大众朗逸承诺2个月到车但7个月后仍未提车   \n",
       "152        217  上汽大众      朗逸       2008款 1.6 自动 品轩版            上海大众朗逸存在严重质量问题   \n",
       "157        222  上汽大众      朗逸       2008款 1.6 自动 品轩版            上海大众朗逸车门异响严重扰人   \n",
       "325        410  上汽大众      朗逸       2008款 1.6 自动 品轩版     上海大众朗逸倒车雷达坏了4S店售后服务极差   \n",
       "436        530  上汽大众      朗逸       2008款 1.6 手动 品轩版           朗逸仪表盘故障导致车辆无法启动   \n",
       "479        576  上汽大众      朗逸       2008款 1.6 自动 品轩版         朗逸刹车倒车时异响4S店推诿不保修   \n",
       "573        673  上汽大众      朗逸     2008款 1.4T DSG 运动版                上海大众朗逸轮胎起包   \n",
       "609        714  上汽大众      朗逸       2008款 1.6 自动 品轩版                 大众朗逸平衡杆异响   \n",
       "658        766  上汽大众      朗逸       2008款 1.6 自动 品轩版            朗逸左边尾灯不严密、空调故障   \n",
       "813        927  上汽大众      朗逸       2008款 1.6 手动 品轩版           上海大众朗逸摇窗机不到一年故障   \n",
       "852        967  上汽大众      朗逸       2008款 1.6 自动 品轩版             上海大众朗逸车门异响严重！   \n",
       "904       1022  上汽大众      朗逸       2008款 1.6 自动 品悠版              上海大众朗逸新车轮胎起包   \n",
       "923       1043  上汽大众      朗逸       2008款 1.6 手动 品轩版            上海大众朗逸车门板等部位异响   \n",
       "1009      1137  上汽大众      朗逸       2008款 1.6 自动 品悠版     大众朗逸油耗表不准、内饰做工差、服务态度差   \n",
       "1066      1196  上汽大众      朗逸       2008款 1.6 自动 品轩版              大众朗逸首保刚过出现异响   \n",
       "1086      1216  上汽大众      朗逸       2008款 1.6 自动 品悠版        上海大众朗逸后挡玻璃漏水、后背箱漏水   \n",
       "1359      1508  上汽大众      朗逸       2011款 1.6 手动 品雅版      上海大众朗逸新车100公里出现变速箱异响   \n",
       "1603      1765  上汽大众      朗逸       2008款 1.6 自动 品悠版              上海大众朗逸后行李箱漏水   \n",
       "1660      1824  上汽大众      朗逸              世博版1.6 AT            上海大众朗逸发动机变速箱漏油   \n",
       "1670      1834  上汽大众      朗逸       2008款 2.0 自动 品尊版            上海大众朗逸音响无法正常使用   \n",
       "1900      2081  上汽大众      朗逸       2008款 1.6 自动 品悠版              上海大众朗逸后行李箱漏水   \n",
       "1918      2102  上汽大众      朗逸       2011款 1.6 手动 品雅版    大众朗逸品雅却一直提不到车说好的时间一拖再拖   \n",
       "2337      2533  上汽大众      朗逸       2008款 1.6 自动 品轩版               大众朗逸车倒车异响严重   \n",
       "2509      2707  上汽大众      朗逸       2011款 1.6 自动 品轩版          朗逸品轩行驶在不平路面时底盘异响   \n",
       "2853      3054  上汽大众      朗逸     2008款 1.4T DSG 运动版       上海大众朗逸右前门异响4S店服务态度差   \n",
       "2952      3154  上汽大众      朗逸   2011款 1.4TSI DSG 品雅版      上海大众朗逸高位刹车灯烧坏驾驶员座椅异响   \n",
       "2976      3178  上汽大众      朗逸   2011款 1.4TSI DSG 品雅版       上海大众朗逸1.4TSI车发动机处漏水   \n",
       "2977      3179  上汽大众      朗逸    2011款 1.4TSI 手动 品轩版          上海大众朗逸车顶灯和车门异响严重   \n",
       "2994      3198  上汽大众      朗逸    2011款 1.4TSI DSG运动版      上海大众朗逸4S店欺瞒消费者逾期提不到车   \n",
       "...        ...   ...     ...                    ...                       ...   \n",
       "203001  289543  上汽大众      朗逸      2017款 1.6L 自动 舒适版        上汽大众朗逸一键启动失效导致无法启动   \n",
       "203034  289592  上汽大众      朗逸      2017款 1.6L 自动 舒适版         上汽大众朗逸发动机异响要求尽快解决   \n",
       "203124  289739  上汽大众      朗逸      2013款 1.6L 手动 舒适版       上汽大众朗逸天窗漏水气囊问题厂家未召回   \n",
       "203180  289829  上汽大众      朗逸      2017款 1.6L 自动 舒适版          上汽大众朗逸发动机舱起火整车自燃   \n",
       "203299  289998  上汽大众      朗逸      2017款 1.6L 自动 舒适版          上汽大众朗逸车内异味严重影响健康   \n",
       "203399  290156  上汽大众      朗逸   2013款 1.6L 自动 风尚版 改款        上汽大众朗逸证件齐全4S店不予做首保   \n",
       "203467  290262  上汽大众      朗逸      2017款 1.6L 自动 舒适版        上汽大众朗逸发动机严重积碳且加速异响   \n",
       "203513  290336  上汽大众      朗逸   2017款 230TSI 双离合 舒适版     上汽大众朗逸后尾灯进个苍蝇 4S店不给解决   \n",
       "203525  290351  上汽大众      朗逸       2011款 1.6 手动 品雅版        上汽大众朗逸车身漏水严重要求尽快解决   \n",
       "203574  290419  上汽大众      朗逸       2008款 1.6 手动 品雅版        上汽大众朗逸两后车门漏水要求尽快解决   \n",
       "203728  290682  上汽大众      朗逸    2011款 1.4TSI 手动 品雅版         上汽大众朗逸踩离合或者刹车转速提高   \n",
       "203739  290696  上汽大众      朗逸   2017款 230TSI 双离合 舒适版     上汽大众朗逸变速箱异响 换挡困难 怠速过高   \n",
       "203746  290710  上汽大众      朗逸    2015款 230TSI DSG舒适版          上汽大众朗逸四条邓禄普轮胎有裂缝   \n",
       "203753  290721  上汽大众      朗逸      2017款 1.6L 自动 风尚版       上汽大众朗逸发动机异响更换发动机后无效   \n",
       "203888  290907  上汽大众      朗逸      2017款 1.6L 自动 舒适版     上汽大众朗逸4S店服务承诺不兑现维修技能差   \n",
       "203950  291006  上汽大众      朗逸       2008款 1.6 手动 品雅版       上汽大众朗逸车门漏水4S店不予妥善解决   \n",
       "203994  291077  上汽大众      朗逸      2017款 1.6L 手动 风尚版       上汽大众朗逸车门及挡把异响希望尽快解决   \n",
       "204012  291108  上汽大众      朗逸      2017款 1.6L 手动 舒适版          上汽大众朗逸动力不足 变速箱抖动   \n",
       "204146  291350  上汽大众      朗逸      2018款 1.5L 自动 舒适版          上汽大众朗逸经销商销售欺骗消费者   \n",
       "204206  291459  上汽大众      朗逸      2017款 1.6L 手动 风尚版         上汽大众朗逸加装配件涉嫌欺骗消费者   \n",
       "204235  291501  上汽大众      朗逸       2015款 1.6 手动 舒适版         上汽大众朗逸转向机故障售后不予质保   \n",
       "204500  291949  上汽大众      朗逸       2008款 1.6 手动 品雅版        上汽大众朗逸两后车门漏水要求尽快解决   \n",
       "204556  292026  上汽大众      朗逸      2015款 1.6L 自动 风尚版          上汽大众朗逸经销商销售承诺未兑现   \n",
       "204624  292169  上汽大众      朗逸       2011款 1.6 手动 品雅版          上汽大众朗逸刹车异响天窗漏水严重   \n",
       "204706  292316  上汽大众      朗逸      2017款 1.6L 自动 舒适版          上汽大众朗逸发动机舱起火整车自燃   \n",
       "204715  292327  上汽大众      朗逸    2011款 1.4TSI DSG品轩版         上汽大众朗逸变速箱阀体故障经常脱挡   \n",
       "204754  292396  上汽大众      朗逸  2014款 1.4TSI DSG蓝驱技术版        上汽大众朗逸DSG变速箱控制单元故障   \n",
       "204883  292605  上汽大众      朗逸      2017款 1.6L 手动 舒适版         上汽大众朗逸下坡转弯时刹车经常失灵   \n",
       "204983  292783  上汽大众      朗逸      2017款 1.6L 自动 风尚版          上汽大众朗逸仪表显示油量数据错误   \n",
       "204990  292803  上汽大众      朗逸      2015款 1.6L 自动 舒适版        上汽大众朗逸车购车一年变速箱部分漏油   \n",
       "\n",
       "                                   question        time condition  \\\n",
       "38                              承诺不兑现,销售欺诈,  2010-05-04      信息审核   \n",
       "96                                   承诺不兑现,  2010-05-12      信息审核   \n",
       "152                              制动系统,故障灯亮,  2010-05-19      信息审核   \n",
       "157                           车身附件及电器,门窗异响,  2010-05-20      信息审核   \n",
       "325                车身附件及电器,行车安全辅助系统故障,服务态度,  2010-06-10      信息审核   \n",
       "436                               发动机,无法启动,  2010-06-24      信息审核   \n",
       "479                                制动系统,异响,  2010-07-01      信息审核   \n",
       "573                                  轮胎,鼓包,  2010-07-15      信息审核   \n",
       "609                             转向系统,平衡杆故障,  2010-07-21      信息审核   \n",
       "658             车身附件及电器,空调问题,车身附件及电器,密封条损坏,  2010-07-27      信息审核   \n",
       "813                         车身附件及电器,车窗升降故障,  2010-08-18      信息审核   \n",
       "852                           车身附件及电器,门窗异响,  2010-08-23      信息审核   \n",
       "904                                  轮胎,鼓包,  2010-08-29      信息审核   \n",
       "923                           车身附件及电器,门窗异响,  2010-08-31      信息审核   \n",
       "1009                     车身附件及电器,仪表故障,服务态度,  2010-09-10      信息审核   \n",
       "1066                                发动机,异响,  2010-09-15      信息审核   \n",
       "1086                          车身附件及电器,车身漏水,  2010-09-17      信息审核   \n",
       "1359                                变速器,异响,  2010-10-16      信息审核   \n",
       "1603                          车身附件及电器,车身漏水,  2010-11-08      信息审核   \n",
       "1660                         发动机,漏油,变速器,漏油,  2010-11-12      信息审核   \n",
       "1670                          车身附件及电器,导航问题,  2010-11-15      信息审核   \n",
       "1900                          车身附件及电器,车身漏水,  2010-12-09      信息审核   \n",
       "1918                                 承诺不兑现,  2010-12-11      信息审核   \n",
       "2337                                发动机,异响,  2011-02-10      信息审核   \n",
       "2509                    前后桥及悬挂系统,底盘异响,人员技术,  2011-02-24      信息审核   \n",
       "2853                     车身附件及电器,门窗异响,服务态度,  2011-03-21      信息审核   \n",
       "2952                     车身附件及电器,座椅故障,服务态度,  2011-03-28      信息审核   \n",
       "2976                          车身附件及电器,车身漏水,  2011-03-29      信息审核   \n",
       "2977                          车身附件及电器,门窗异响,  2011-03-29      信息审核   \n",
       "2994                                  销售欺诈,  2011-03-30      信息审核   \n",
       "...                                     ...         ...       ...   \n",
       "203001                            发动机,无法启动,  2018-07-09      厂家受理   \n",
       "203034                              发动机,异响,  2018-07-09      厂家受理   \n",
       "203124             车身附件及电器,天窗漏水,其他原因,厂家不召回,  2018-07-10      厂家受理   \n",
       "203180                        车身附件及电器,车辆自燃,  2018-07-10      厂家受理   \n",
       "203299                        车身附件及电器,车内异味,  2018-07-11      处理反馈   \n",
       "203399                       承诺不兑现,服务承诺不兑现,  2018-07-12      厂家受理   \n",
       "203467                       发动机,异响,发动机,抖动,  2018-07-12      厂家受理   \n",
       "203513                        车身附件及电器,车灯进水,  2018-07-13      厂家受理   \n",
       "203525                        车身附件及电器,车身漏水,  2018-07-13      厂家受理   \n",
       "203574                        车身附件及电器,车身漏水,  2018-07-13      用户评分   \n",
       "203728                            发动机,怠速不稳,  2018-07-14      厂家受理   \n",
       "203739            发动机,怠速不稳,变速器,异响,变速器,无法换挡,  2018-07-14      信息审核   \n",
       "203746                               轮胎,开裂,  2018-07-15      厂家受理   \n",
       "203753                              发动机,异响,  2018-07-15      厂家受理   \n",
       "203888  人员技术,维修技术差,服务收费,变相收费,承诺不兑现,服务承诺不兑现,  2018-07-15      厂家受理   \n",
       "203950             车身附件及电器,车身漏水,服务态度,不解决问题,  2018-07-16      厂家受理   \n",
       "203994             变速器,挡把总成故障,车身附件及电器,门窗异响,  2018-07-16      信息审核   \n",
       "204012                     发动机,功率不足,变速器,抖动,  2018-07-16      厂家受理   \n",
       "204146                          销售欺诈,与宣传不符,  2018-07-17      厂家受理   \n",
       "204206                服务收费,变相收费,销售欺诈,与宣传不符,  2018-07-18      厂家受理   \n",
       "204235                          转向系统,转向机故障,  2018-07-18      厂家受理   \n",
       "204500                        车身附件及电器,车身漏水,  2018-07-20      厂家受理   \n",
       "204556                       承诺不兑现,销售承诺不兑现,  2018-07-20      厂家受理   \n",
       "204624                制动系统,异响,车身附件及电器,天窗漏水,  2018-07-21      厂家受理   \n",
       "204706             车身附件及电器,车辆自燃,服务态度,不解决问题,  2018-07-22      厂家受理   \n",
       "204715                    变速器,滑阀箱故障,变速器,脱挡,  2018-07-22      厂家受理   \n",
       "204754                           变速器,滑阀箱故障,  2018-07-22      厂家受理   \n",
       "204883                           制动系统,刹车失灵,  2018-07-23      信息审核   \n",
       "204983                       车身附件及电器,汽油泵故障,  2018-07-24      信息审核   \n",
       "204990                              变速器,漏油,  2018-07-24      信息审核   \n",
       "\n",
       "                                                      url    厂家    品牌    车系  \\\n",
       "38      http://www.12365auto.com/zlts/2010-05-04/20100...  上汽大众    大众    朗逸   \n",
       "96      http://www.12365auto.com/zlts/2010-05-12/20100...  上汽大众    大众    朗逸   \n",
       "152     http://www.12365auto.com/zlts/2010-05-19/20100...  上汽大众    大众    朗逸   \n",
       "157     http://www.12365auto.com/zlts/2010-05-20/20100...  上汽大众    大众    朗逸   \n",
       "325     http://www.12365auto.com/zlts/2010-06-10/20100...  上汽大众    大众    朗逸   \n",
       "436     http://www.12365auto.com/zlts/2010-06-24/20100...  上汽大众    大众    朗逸   \n",
       "479     http://www.12365auto.com/zlts/2010-07-01/20100...  上汽大众    大众    朗逸   \n",
       "573     http://www.12365auto.com/zlts/2010-07-15/20100...  上汽大众    大众    朗逸   \n",
       "609     http://www.12365auto.com/zlts/2010-07-21/20100...  上汽大众    大众    朗逸   \n",
       "658     http://www.12365auto.com/zlts/2010-07-27/20100...  上汽大众    大众    朗逸   \n",
       "813     http://www.12365auto.com/zlts/2010-08-18/20100...  上汽大众    大众    朗逸   \n",
       "852     http://www.12365auto.com/zlts/2010-08-23/20100...  上汽大众    大众    朗逸   \n",
       "904     http://www.12365auto.com/zlts/2010-08-29/20100...  上汽大众    大众    朗逸   \n",
       "923     http://www.12365auto.com/zlts/2010-08-31/20100...  上汽大众    大众    朗逸   \n",
       "1009    http://www.12365auto.com/zlts/2010-09-10/20100...  上汽大众    大众    朗逸   \n",
       "1066    http://www.12365auto.com/zlts/2010-09-15/20100...  上汽大众    大众    朗逸   \n",
       "1086    http://www.12365auto.com/zlts/2010-09-17/20100...  上汽大众    大众    朗逸   \n",
       "1359    http://www.12365auto.com/zlts/2010-10-16/20101...  上汽大众    大众    朗逸   \n",
       "1603    http://www.12365auto.com/zlts/2010-11-08/20101...  上汽大众    大众    朗逸   \n",
       "1660    http://www.12365auto.com/zlts/2010-11-12/20101...  上汽大众    大众    朗逸   \n",
       "1670    http://www.12365auto.com/zlts/2010-11-15/20101...  上汽大众    大众    朗逸   \n",
       "1900    http://www.12365auto.com/zlts/2010-12-09/20101...  上汽大众    大众    朗逸   \n",
       "1918    http://www.12365auto.com/zlts/2010-12-11/20101...  上汽大众    大众    朗逸   \n",
       "2337    http://www.12365auto.com/zlts/2011-02-10/20110...  上汽大众    大众    朗逸   \n",
       "2509    http://www.12365auto.com/zlts/2011-02-24/20110...  上汽大众    大众    朗逸   \n",
       "2853    http://www.12365auto.com/zlts/2011-03-21/20110...  上汽大众    大众    朗逸   \n",
       "2952    http://www.12365auto.com/zlts/2011-03-28/20110...  上汽大众    大众    朗逸   \n",
       "2976    http://www.12365auto.com/zlts/2011-03-29/20110...  上汽大众    大众    朗逸   \n",
       "2977    http://www.12365auto.com/zlts/2011-03-29/20110...  上汽大众    大众    朗逸   \n",
       "2994    http://www.12365auto.com/zlts/2011-03-30/20110...  上汽大众    大众    朗逸   \n",
       "...                                                   ...   ...   ...   ...   \n",
       "203001  http://www.12365auto.com/zlts/20180709/289543....  None  None  None   \n",
       "203034  http://www.12365auto.com/zlts/20180709/289592....  None  None  None   \n",
       "203124  http://www.12365auto.com/zlts/20180710/289739....  None  None  None   \n",
       "203180  http://www.12365auto.com/zlts/20180710/289829....  None  None  None   \n",
       "203299  http://www.12365auto.com/zlts/20180711/289998....  None  None  None   \n",
       "203399  http://www.12365auto.com/zlts/20180712/290156....  None  None  None   \n",
       "203467  http://www.12365auto.com/zlts/20180712/290262....  None  None  None   \n",
       "203513  http://www.12365auto.com/zlts/20180713/290336....  None  None  None   \n",
       "203525  http://www.12365auto.com/zlts/20180713/290351....  None  None  None   \n",
       "203574  http://www.12365auto.com/zlts/20180713/290419....  None  None  None   \n",
       "203728  http://www.12365auto.com/zlts/20180714/290682....  None  None  None   \n",
       "203739  http://www.12365auto.com/zlts/20180714/290696....  None  None  None   \n",
       "203746  http://www.12365auto.com/zlts/20180715/290710....  None  None  None   \n",
       "203753  http://www.12365auto.com/zlts/20180715/290721....  None  None  None   \n",
       "203888  http://www.12365auto.com/zlts/20180715/290907....  None  None  None   \n",
       "203950  http://www.12365auto.com/zlts/20180716/291006....  None  None  None   \n",
       "203994  http://www.12365auto.com/zlts/20180716/291077....  None  None  None   \n",
       "204012  http://www.12365auto.com/zlts/20180716/291108....  None  None  None   \n",
       "204146  http://www.12365auto.com/zlts/20180717/291350....  None  None  None   \n",
       "204206  http://www.12365auto.com/zlts/20180718/291459....  None  None  None   \n",
       "204235  http://www.12365auto.com/zlts/20180718/291501....  None  None  None   \n",
       "204500  http://www.12365auto.com/zlts/20180720/291949....  None  None  None   \n",
       "204556  http://www.12365auto.com/zlts/20180720/292026....  None  None  None   \n",
       "204624  http://www.12365auto.com/zlts/20180721/292169....  None  None  None   \n",
       "204706  http://www.12365auto.com/zlts/20180722/292316....  None  None  None   \n",
       "204715  http://www.12365auto.com/zlts/20180722/292327....  None  None  None   \n",
       "204754  http://www.12365auto.com/zlts/20180722/292396....  None  None  None   \n",
       "204883  http://www.12365auto.com/zlts/20180723/292605....  None  None  None   \n",
       "204983  http://www.12365auto.com/zlts/20180724/292783....  None  None  None   \n",
       "204990  http://www.12365auto.com/zlts/20180724/292803....  None  None  None   \n",
       "\n",
       "          车型  \n",
       "38      None  \n",
       "96      None  \n",
       "152     None  \n",
       "157     None  \n",
       "325     None  \n",
       "436     None  \n",
       "479     None  \n",
       "573     None  \n",
       "609     None  \n",
       "658     None  \n",
       "813     None  \n",
       "852     None  \n",
       "904     None  \n",
       "923     None  \n",
       "1009    None  \n",
       "1066    None  \n",
       "1086    None  \n",
       "1359    None  \n",
       "1603    None  \n",
       "1660    None  \n",
       "1670    None  \n",
       "1900    None  \n",
       "1918    None  \n",
       "2337    None  \n",
       "2509    None  \n",
       "2853    None  \n",
       "2952    None  \n",
       "2976    None  \n",
       "2977    None  \n",
       "2994    None  \n",
       "...      ...  \n",
       "203001  None  \n",
       "203034  None  \n",
       "203124  None  \n",
       "203180  None  \n",
       "203299  None  \n",
       "203399  None  \n",
       "203467  None  \n",
       "203513  None  \n",
       "203525  None  \n",
       "203574  None  \n",
       "203728  None  \n",
       "203739  None  \n",
       "203746  None  \n",
       "203753  None  \n",
       "203888  None  \n",
       "203950  None  \n",
       "203994  None  \n",
       "204012  None  \n",
       "204146  None  \n",
       "204206  None  \n",
       "204235  None  \n",
       "204500  None  \n",
       "204556  None  \n",
       "204624  None  \n",
       "204706  None  \n",
       "204715  None  \n",
       "204754  None  \n",
       "204883  None  \n",
       "204983  None  \n",
       "204990  None  \n",
       "\n",
       "[2115 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "top10 = ly.groupby(['car_small'])['id'].count().reset_index()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = top10[top10['id']>60]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp.to_csv('年款_投诉.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "1027汽油系\n",
      "1035系列\n",
      "110P系列\n",
      "11座轻型客车\n",
      "2012款新速腾\n",
      "206cc\n",
      "307SW\n",
      "4108\n",
      "485\n",
      "4系列\n",
      "5米319座\n",
      "6*4牵引车\n",
      "6816\n",
      "700P\n",
      "717\n",
      "747\n",
      "757\n",
      "86H\n",
      "ASX劲炫\n",
      "BJ 212\n",
      "C-MAX\n",
      "C4世嘉\n",
      "CC\n",
      "CC（进口）\n",
      "D-MAX\n",
      "D22皮卡\n",
      "D28\n",
      "DS 4S\n",
      "DS 5LS\n",
      "DS 7\n",
      "DS4\n",
      "DS5\n",
      "DS6\n",
      "E100\n",
      "EC系列\n",
      "EQ5I6I\n",
      "EU系列\n",
      "EV系列\n",
      "EX系列\n",
      "E系列\n",
      "F3000\n",
      "F3000-380\n",
      "Ghibli\n",
      "Giulia\n",
      "GranTurismo\n",
      "H3-3030\n",
      "HIACE\n",
      "HOWO轻卡\n",
      "HX-5028\n",
      "J0\n",
      "J6F系列商用车\n",
      "J6L\n",
      "J6l\n",
      "JAC康玲【箱货】\n",
      "JX6602VDF\n",
      "K17A\n",
      "K5x\n",
      "KV600厢式货车\n",
      "KX CROSS\n",
      "Kuga\n",
      "LANNIA 蓝鸟\n",
      "LCK6601D3E1\n",
      "LZ5244CSPEL\n",
      "Leon\n",
      "Levante\n",
      "M1\n",
      "MINI\n",
      "MINI CLUBMAN\n",
      "MINI COUNTRYMAN\n",
      "MINI COUPE\n",
      "MINI JCW\n",
      "MINI PACEMAN\n",
      "MODEL S\n",
      "MODEL X\n",
      "Mustang\n",
      "N36N\n",
      "N8\n",
      "NF御翔\n",
      "NV200\n",
      "PN货车\n",
      "PT漫步者\n",
      "Passat\n",
      "Polo\n",
      "RAV4\n",
      "RAV4荣放\n",
      "Rapide\n",
      "SENIA R7\n",
      "SLS赛威\n",
      "SWM斯威X3\n",
      "SWM斯威X7\n",
      "SY5313THB\n",
      "Sprinter\n",
      "T1\n",
      "T3\n",
      "T60\n",
      "T6货车\n",
      "T7\n",
      "T7440\n",
      "Tiguan\n",
      "U5 SUV\n",
      "V3牵引车\n",
      "V3菱悦\n",
      "V5菱致\n",
      "V6菱仕\n",
      "WEY VV5\n",
      "WEY VV7\n",
      "YARiS L 致享\n",
      "YARiS L 致炫\n",
      "Yeti\n",
      "Yeti（进口）\n",
      "a5l\n",
      "d70雷丁电轿\n",
      "g3w45\n",
      "i3\n",
      "smart forfour\n",
      "smart fortwo\n",
      "一汽J6\n",
      "一汽J6L\n",
      "一汽J6平头柴油自卸汽车\n",
      "一汽红塔金铃\n",
      "一汽解放CA3600\n",
      "万达\n",
      "三菱菱绅\n",
      "上汽大通EG10\n",
      "上汽大通G10\n",
      "上汽大通T60\n",
      "上汽大通V80\n",
      "专用校车\n",
      "专用车\n",
      "世嘉\n",
      "丘比特\n",
      "东南DX3\n",
      "东南DX7\n",
      "东南菱帅\n",
      "东方之子\n",
      "东方之子cross\n",
      "东方俊峰\n",
      "东风\n",
      "东风A9\n",
      "东风中型载货汽车\n",
      "东风俊风\n",
      "东风华神\n",
      "东风嘉龙\n",
      "东风多利卡S3300\n",
      "东风天锦\n",
      "东风天龙\n",
      "东风小王子\n",
      "东风御风\n",
      "东风皮卡\n",
      "东风超龙客车\n",
      "东风超龙校车\n",
      "两轮摩托车\n",
      "中兴C3\n",
      "中兴GX3\n",
      "中华H220\n",
      "中华H230\n",
      "中华H3\n",
      "中华H320\n",
      "中华H330\n",
      "中华H530\n",
      "中华V3\n",
      "中华V5\n",
      "中华V6\n",
      "中华尊驰\n",
      "中华酷宝\n",
      "中华骏捷\n",
      "中华骏捷Cross\n",
      "中华骏捷FRV\n",
      "中华骏捷FSV\n",
      "中国重汽豪沃轻卡\n",
      "中国龙\n",
      "中型专业车\n",
      "中型专用校车\n",
      "中型自卸车\n",
      "中性客车\n",
      "中意V5\n",
      "丰田佳美\n",
      "丰顺\n",
      "乐途\n",
      "乐风\n",
      "乐风RV\n",
      "乐驰\n",
      "乐骋\n",
      "乘龙H7\n",
      "乘龙L3\n",
      "九龙A5\n",
      "九龙A6\n",
      "云100\n",
      "云汽东风\n",
      "五十铃mu-X\n",
      "五征奥驰2000\n",
      "五菱之光\n",
      "五菱之光小卡\n",
      "五菱宏光\n",
      "五菱宏光S\n",
      "五菱宏光S3\n",
      "五菱小旋风\n",
      "五菱征程\n",
      "五菱扬光\n",
      "五菱荣光\n",
      "五菱荣光V\n",
      "五菱荣光小卡\n",
      "五菱鸿途\n",
      "享御\n",
      "京城海狮\n",
      "仓棚\n",
      "伊兰特\n",
      "伊兰特EV\n",
      "伊思坦纳\n",
      "伊柯丽斯\n",
      "众泰2008\n",
      "众泰5008\n",
      "众泰E200\n",
      "众泰M300\n",
      "众泰SR7\n",
      "众泰SR9\n",
      "众泰T200\n",
      "众泰T300\n",
      "众泰T500\n",
      "众泰T600\n",
      "众泰T600 Coupe\n",
      "众泰T700\n",
      "众泰V10\n",
      "众泰Z100\n",
      "众泰Z200\n",
      "众泰Z200HB\n",
      "众泰Z300\n",
      "众泰Z500\n",
      "众泰Z560\n",
      "众泰Z700\n",
      "优6 SUV\n",
      "优优\n",
      "优优2代\n",
      "优利欧\n",
      "优劲\n",
      "优胜2代\n",
      "优雅\n",
      "优雅2代\n",
      "传奇\n",
      "传祺GA3\n",
      "传祺GA3S视界\n",
      "传祺GA4\n",
      "传祺GA5\n",
      "传祺GA5新能源\n",
      "传祺GA6\n",
      "传祺GA8\n",
      "传祺GE3\n",
      "传祺GS3\n",
      "传祺GS4\n",
      "传祺GS4新能源\n",
      "传祺GS5\n",
      "传祺GS5 Super\n",
      "传祺GS8\n",
      "伽途ix5\n",
      "伽途ix7\n",
      "佳乐\n",
      "佳宝\n",
      "佳宝T50\n",
      "佳宝T51\n",
      "佳宝T57\n",
      "佳宝V52\n",
      "佳宝V70\n",
      "佳宝V77\n",
      "佳宝V80\n",
      "佳美\n",
      "依维柯Power Daily\n",
      "俊风\n",
      "俊风CV03\n",
      "保时捷718\n",
      "保时捷911\n",
      "保时捷Boxster\n",
      "保时捷Cayenne\n",
      "保时捷Macan\n",
      "保时捷Panamera\n",
      "保时捷cayman\n",
      "傲虎\n",
      "傲骏\n",
      "元\n",
      "元新能源\n",
      "克莱斯勒300C\n",
      "全新胜达\n",
      "全球鹰K10\n",
      "全球鹰K11\n",
      "全球鹰K17\n",
      "全球鹰K17A\n",
      "全系\n",
      "全顺\n",
      "公共交通\n",
      "兰德酷路泽\n",
      "兰德酷路泽（进口）\n",
      "冠道\n",
      "凌傲\n",
      "凌派\n",
      "凌渡\n",
      "凌源\n",
      "凌轩\n",
      "凌铃\n",
      "凯威\n",
      "凯尊\n",
      "凯捷\n",
      "凯旋\n",
      "凯泽西\n",
      "凯特\n",
      "凯绅\n",
      "凯美瑞\n",
      "凯美瑞（进口）\n",
      "凯翼C3\n",
      "凯翼C3R\n",
      "凯翼E3\n",
      "凯翼V3\n",
      "凯翼X3\n",
      "凯越\n",
      "凯运\n",
      "凯迪拉克ATS-L\n",
      "凯迪拉克ATS（进口）\n",
      "凯迪拉克CT6\n",
      "凯迪拉克CTS（进口）\n",
      "凯迪拉克SRX\n",
      "凯迪拉克XT5\n",
      "凯迪拉克XTS\n",
      "凯迪拉克XTS（进口）\n",
      "凯锐\n",
      "凯雷德ESCALADE\n",
      "凯马\n",
      "凯马轻型厢式国四货车\n",
      "创酷\n",
      "利亚纳\n",
      "利亚纳A6\n",
      "别克GL6\n",
      "别克GL8\n",
      "别克君威\n",
      "力帆320\n",
      "力帆330\n",
      "力帆520\n",
      "力帆520i\n",
      "力帆530\n",
      "力帆620\n",
      "力帆630\n",
      "力帆720\n",
      "力帆820\n",
      "力帆X50\n",
      "力帆X60\n",
      "力狮\n",
      "劲卡\n",
      "劲客\n",
      "劲炫ASX\n",
      "劳恩斯\n",
      "劳恩斯酷派\n",
      "勋龙\n",
      "北京20\n",
      "北京40\n",
      "北京80\n",
      "北京BJ40\n",
      "北京（BJ）20\n",
      "北斗星\n",
      "北斗星X5\n",
      "北汽007\n",
      "北汽ES210\n",
      "北汽陆铃教练车\n",
      "十通\n",
      "华北骏风\n",
      "华泰B11\n",
      "华泰EV160R\n",
      "华泰XEV260\n",
      "华神\n",
      "单桥混泥土搅拌车\n",
      "南骏\n",
      "南骏NJP4010D6\n",
      "博悦\n",
      "博瑞\n",
      "博瑞GE\n",
      "博越\n",
      "卡威\n",
      "卡威K1\n",
      "卡缤\n",
      "卡罗拉\n",
      "厢式货车\n",
      "厦门金龙\n",
      "厦门金龙K01\n",
      "双环SCEO\n",
      "发现\n",
      "发现神行\n",
      "发现神行（进口）\n",
      "吉利EC8\n",
      "吉利GC7\n",
      "吉利GX2\n",
      "吉利GX7\n",
      "吉利SC3\n",
      "吉利SC5-RV\n",
      "吉利SC6\n",
      "吉利SX7\n",
      "吉奥GX6\n",
      "吉姆尼\n",
      "同悦\n",
      "同悦RS\n",
      "名图\n",
      "名爵3\n",
      "名爵3SW\n",
      "名爵5\n",
      "名爵6\n",
      "名爵7\n",
      "名爵TF\n",
      "名爵ZS\n",
      "名驭\n",
      "君威\n",
      "君越\n",
      "君阁\n",
      "启悦\n",
      "启腾EX80\n",
      "启腾M70\n",
      "启辰D50\n",
      "启辰D60\n",
      "启辰M50V\n",
      "启辰R30\n",
      "启辰R50\n",
      "启辰R50X\n",
      "启辰T70\n",
      "启辰T70X\n",
      "启辰T90\n",
      "和悦\n",
      "和悦A13\n",
      "和悦A13 RS\n",
      "和悦A30\n",
      "哈弗CUV\n",
      "哈弗H1\n",
      "哈弗H2\n",
      "哈弗H2s\n",
      "哈弗H3\n",
      "哈弗H4\n",
      "哈弗H5\n",
      "哈弗H6\n",
      "哈弗H6 Coupe\n",
      "哈弗H7\n",
      "哈弗H8\n",
      "哈弗H9\n",
      "哈弗M6\n",
      "哈飞小霸王\n",
      "哈飞锐意\n",
      "哥瑞\n",
      "唐\n",
      "唯雅诺\n",
      "唯雅诺（进口）\n",
      "商务型\n",
      "商用\n",
      "嘉年华\n",
      "嘉年华（进口）\n",
      "嘉誉\n",
      "四轴自卸货车\n",
      "国五星凯马\n",
      "国产\n",
      "图雅诺\n",
      "圣达菲经典\n",
      "坤程皮卡\n",
      "坦途 皮卡\n",
      "埃尔法\n",
      "城市\n",
      "城市公交客车\n",
      "城市客车\n",
      "域虎\n",
      "塔利斯曼\n",
      "塞纳\n",
      "夏利\n",
      "夏利A+\n",
      "夏利N3\n",
      "夏利N5\n",
      "夏利N7\n",
      "夏朗\n",
      "多利卡\n",
      "大7 MPV\n",
      "大7 SUV\n",
      "大C4毕加索\n",
      "大MPV\n",
      "大众EOS\n",
      "大切诺基（进口）\n",
      "大力神\n",
      "大地货车\n",
      "大型客车\n",
      "大型普通客车\n",
      "大型货车\n",
      "大客\n",
      "大客车\n",
      "大捷龙\n",
      "大柴神\n",
      "大货车\n",
      "大迈X5\n",
      "大迈X7\n",
      "大通D90\n",
      "大通G10\n",
      "大通T60\n",
      "大通V80\n",
      "大陆\n",
      "天V430\n",
      "天挺400\n",
      "天然气牵引车\n",
      "天然气（LNG）德龙系列\n",
      "天籁\n",
      "天语SX4\n",
      "天语·尚悦\n",
      "天逸 C5 AIRCROSS\n",
      "天锦\n",
      "天龙\n",
      "奇瑞A1\n",
      "奇瑞A3\n",
      "奇瑞A5\n",
      "奇瑞E3\n",
      "奇瑞E5\n",
      "奇瑞QQ\n",
      "奇瑞QQ3\n",
      "奇瑞QQ6\n",
      "奇瑞QQme\n",
      "奇瑞eQ\n",
      "奇瑞eQ1\n",
      "奇骏\n",
      "奔奔\n",
      "奔奔EV\n",
      "奔奔LOVE\n",
      "奔奔MINI\n",
      "奔奔mini-e\n",
      "奔腾B30\n",
      "奔腾B50\n",
      "奔腾B70\n",
      "奔腾B90\n",
      "奔腾X40\n",
      "奔腾X80\n",
      "奔驰AMG\n",
      "奔驰A级\n",
      "奔驰B级\n",
      "奔驰CL\n",
      "奔驰CLA（进口）\n",
      "奔驰CLK\n",
      "奔驰CLS\n",
      "奔驰C级\n",
      "奔驰C级（进口）\n",
      "奔驰E级\n",
      "奔驰E级（进口）\n",
      "奔驰GL\n",
      "奔驰GLA\n",
      "奔驰GLC\n",
      "奔驰GLE\n",
      "奔驰GLK\n",
      "奔驰GLK（进口）\n",
      "奔驰GLS\n",
      "奔驰G级\n",
      "奔驰M级\n",
      "奔驰R级\n",
      "奔驰SL\n",
      "奔驰SLC\n",
      "奔驰SLK\n",
      "奔驰S级\n",
      "奔驰V级\n",
      "奔驰运油车\n",
      "奥丁\n",
      "奥微1500\n",
      "奥德赛\n",
      "奥拓\n",
      "奥普力\n",
      "奥轩G5\n",
      "奥轩GX5\n",
      "奥迪A1\n",
      "奥迪A3\n",
      "奥迪A3新能源(进口)\n",
      "奥迪A3（进口）\n",
      "奥迪A4\n",
      "奥迪A4L\n",
      "奥迪A4（进口）\n",
      "奥迪A5\n",
      "奥迪A6L\n",
      "奥迪A6（进口）\n",
      "奥迪A7\n",
      "奥迪A8\n",
      "奥迪Q3\n",
      "奥迪Q3（进口）\n",
      "奥迪Q5\n",
      "奥迪Q5（进口）\n",
      "奥迪Q7\n",
      "奥迪S3\n",
      "奥迪S5\n",
      "奥迪TT\n",
      "奥迪TTS\n",
      "奥铃\n",
      "奥驰1800\n",
      "奥龙\n",
      "好运\n",
      "威乐\n",
      "威姿\n",
      "威志\n",
      "威志V2\n",
      "威志V5\n",
      "威旺007\n",
      "威旺205\n",
      "威旺306\n",
      "威旺M20\n",
      "威旺M30\n",
      "威旺M35\n",
      "威旺M50F\n",
      "威旺S50\n",
      "威朗\n",
      "威虎\n",
      "威虎G3\n",
      "威铃\n",
      "威霆\n",
      "威霆Vito\n",
      "威飒\n",
      "威驰\n",
      "威驰FS\n",
      "威麟V5\n",
      "威麟X5\n",
      "宇通ZK6100H\n",
      "宇通ZK6110HN01Z\n",
      "宇通ZK6831H\n",
      "宇通ZK6860H\n",
      "宇通ZK6898H\n",
      "宇通客车\n",
      "安德拉\n",
      "安驰\n",
      "安驰皮卡\n",
      "安驰金牛皮卡\n",
      "宋\n",
      "宋MAX\n",
      "宋新能源\n",
      "宝典\n",
      "宝利格\n",
      "宝威\n",
      "宝斯通\n",
      "宝来\n",
      "宝沃BX5\n",
      "宝沃BX7\n",
      "宝马1系\n",
      "宝马2系\n",
      "宝马2系多功能旅行车\n",
      "宝马2系旅行车\n",
      "宝马2系运动旅行车\n",
      "宝马3系\n",
      "宝马3系GT\n",
      "宝马3系（进口）\n",
      "宝马4系\n",
      "宝马5系\n",
      "宝马5系GT\n",
      "宝马5系新能源\n",
      "宝马5系（进口）\n",
      "宝马6系\n",
      "宝马6系GT\n",
      "宝马7系\n",
      "宝马X1\n",
      "宝马X1新能源\n",
      "宝马X3\n",
      "宝马X4\n",
      "宝马X5\n",
      "宝马X6\n",
      "宝马Z4\n",
      "宝骏310\n",
      "宝骏310W\n",
      "宝骏360\n",
      "宝骏510\n",
      "宝骏530\n",
      "宝骏560\n",
      "宝骏610\n",
      "宝骏630\n",
      "宝骏730\n",
      "宝骏E100\n",
      "客车\n",
      "宽体顺达\n",
      "宾悦\n",
      "富康\n",
      "小卡\n",
      "小康\n",
      "小康C31\n",
      "小康C32\n",
      "小康C35\n",
      "小康C36\n",
      "小康C37\n",
      "小康K01\n",
      "小康K02\n",
      "小康K07\n",
      "小康K07II\n",
      "小康K07S\n",
      "小康K17\n",
      "小康V07S\n",
      "小康V22\n",
      "小康V27\n",
      "小康V29\n",
      "小柴神\n",
      "小海狮X30\n",
      "小老虎\n",
      "小货车\n",
      "小贵族\n",
      "小超人\n",
      "小霸王\n",
      "尚酷\n",
      "山东五征奥驰2000\n",
      "峻岭\n",
      "巴博斯BRABUS\n",
      "帅客\n",
      "帅舰\n",
      "帅铃\n",
      "帅铃T6\n",
      "帅驰\n",
      "希旺\n",
      "帕拉丁\n",
      "帕杰罗V73\n",
      "帕杰罗·劲畅\n",
      "帕杰罗（进口）\n",
      "帕萨特\n",
      "帝豪\n",
      "帝豪GL\n",
      "帝豪GS\n",
      "帝豪新能源\n",
      "平头柴油载货汽车\n",
      "平板自卸半挂车\n",
      "幻速H2\n",
      "幻速H2V\n",
      "幻速H3\n",
      "幻速H3F\n",
      "幻速H6\n",
      "幻速S2\n",
      "幻速S3\n",
      "幻速S3L\n",
      "幻速S5\n",
      "幻速S6\n",
      "幻速S7\n",
      "幼儿专用校车\n",
      "幼儿园校车\n",
      "广汽本田凌派\n",
      "庆铃F系列\n",
      "庆铃N系列\n",
      "庆铃TAGA\n",
      "庆铃T系列\n",
      "康玲\n",
      "康铃\n",
      "开沃D11\n",
      "开瑞K50\n",
      "开瑞K60\n",
      "开瑞优优\n",
      "开迪\n",
      "得利卡\n",
      "得意\n",
      "御捷E驰\n",
      "御捷电动汽车\n",
      "御轩\n",
      "御风S16\n",
      "微卡\n",
      "微车\n",
      "微面\n",
      "德隆\n",
      "德龙\n",
      "德龙M3000\n",
      "德龙新M3000\n",
      "志俊\n",
      "志翔\n",
      "快运\n",
      "快运王\n",
      "思域\n",
      "思域Civic\n",
      "思迪\n",
      "思铂睿\n",
      "思铭\n",
      "思锐\n",
      "总裁\n",
      "悦动\n",
      "悦悦\n",
      "悦纳\n",
      "悦纳RV\n",
      "悦翔\n",
      "悦翔V3\n",
      "悦翔V5\n",
      "悦翔V7\n",
      "慕尚\n",
      "戈蓝\n",
      "成功V1\n",
      "成都王牌CDW5041XXXYHA104\n",
      "战旗\n",
      "房车\n",
      "扬子19座客车\n",
      "扬子江\n",
      "拉古那\n",
      "拓陆者\n",
      "指南者\n",
      "指南者（进口）\n",
      "挑战者\n",
      "捷冠\n",
      "捷恩斯\n",
      "捷豹F-PACE\n",
      "捷豹F-TYPE\n",
      "捷豹XE\n",
      "捷豹XEL\n",
      "捷豹XF\n",
      "捷豹XFL\n",
      "捷豹XJ\n",
      "捷达\n",
      "探界者\n",
      "探索者Ⅲ\n",
      "探险者\n",
      "揽福\n",
      "揽胜\n",
      "揽胜星脉\n",
      "揽胜极光\n",
      "揽胜极光（进口）\n",
      "揽胜运动版\n",
      "揽胜运动版新能源\n",
      "撼路者\n",
      "斯巴鲁BRZ\n",
      "斯巴鲁XV\n",
      "斯帕克SPARK\n",
      "新M3000\n",
      "新世代全顺\n",
      "新动力\n",
      "新圣达菲\n",
      "新大威燃气车380\n",
      "新宝来\n",
      "新朗逸\n",
      "新豹MINI\n",
      "旗云\n",
      "旗云1\n",
      "旗云2\n",
      "旗云3\n",
      "旗云5\n",
      "旗胜F1\n",
      "旗舰A9\n",
      "无限\n",
      "日产GT-R\n",
      "日野牵引车\n",
      "时代\n",
      "时代康瑞\n",
      "时代福锐\n",
      "时代金刚\n",
      "时代金刚588\n",
      "时代金刚系列\n",
      "时代驭菱 轻卡\n",
      "昂科威\n",
      "昂科拉\n",
      "昂科雷\n",
      "昊锐\n",
      "昊锐（进口）\n",
      "昌河A6\n",
      "昌河M50\n",
      "昌河M70\n",
      "昌河Q25\n",
      "昌河Q35\n",
      "昌河Q7\n",
      "明锐\n",
      "昕动\n",
      "昕锐\n",
      "星旺\n",
      "星旺L\n",
      "星朗\n",
      "星锐\n",
      "晨风\n",
      "普力马\n",
      "普拉多\n",
      "普拉多（进口）\n",
      "普锐斯\n",
      "景程\n",
      "景逸\n",
      "景逸S50\n",
      "景逸SUV\n",
      "景逸X3\n",
      "景逸X5\n",
      "景逸X6\n",
      "景逸XV\n",
      "晶锐\n",
      "智尚S30\n",
      "智尚S35\n",
      "智跑\n",
      "朗动\n",
      "朗境\n",
      "朗行\n",
      "朗逸\n",
      "本田CR-V\n",
      "本田UR-V\n",
      "本田XR-V\n",
      "杰勋\n",
      "杰德\n",
      "杰路驰\n",
      "极睿\n",
      "林肯MKC\n",
      "林肯MKX\n",
      "林肯MKZ\n",
      "林荫大道\n",
      "柯兰多\n",
      "柯斯达\n",
      "柯珞克\n",
      "柯迪亚克\n",
      "柴油小卡\n",
      "标准型\n",
      "标致2008\n",
      "标致206\n",
      "标致207\n",
      "标致207 （进口）\n",
      "标致3008\n",
      "标致3008 （进口）\n",
      "标致301\n",
      "标致307\n",
      "标致308\n",
      "标致308 （进口）\n",
      "标致308S\n",
      "标致308SW\n",
      "标致4008\n",
      "标致408\n",
      "标致5008\n",
      "标致508\n",
      "标致RCZ\n",
      "校车\n",
      "格尔发\n",
      "格尔发K3L\n",
      "格尔发重型自卸货车\n",
      "桑塔纳\n",
      "桑塔纳经典\n",
      "梅甘娜\n",
      "森林人\n",
      "森雅\n",
      "森雅M80\n",
      "森雅R7\n",
      "森雅S80\n",
      "楼兰\n",
      "欢动\n",
      "欧冠490\n",
      "欧力威\n",
      "欧尚\n",
      "欧尚X70A\n",
      "欧悦搏\n",
      "欧曼\n",
      "欧朗\n",
      "欧蓝德\n",
      "欧蓝德（进口）\n",
      "欧诺\n",
      "欧辉\n",
      "欧铃\n",
      "欧铃牌\n",
      "欧铃牌ZB1033ASC3F\n",
      "欧陆\n",
      "欧霸\n",
      "欧马可\n",
      "歌诗图\n",
      "比亚迪F0\n",
      "比亚迪F3\n",
      "比亚迪F3R\n",
      "比亚迪F6\n",
      "比亚迪G3\n",
      "比亚迪G3R\n",
      "比亚迪G5\n",
      "比亚迪G6\n",
      "比亚迪L3\n",
      "比亚迪M6\n",
      "比亚迪S6\n",
      "比亚迪S7\n",
      "比亚迪e5\n",
      "比亚迪e6\n",
      "比速M3\n",
      "比速T3\n",
      "比速T5\n",
      "毕加索\n",
      "民意\n",
      "水泥罐车\n",
      "永源A380\n",
      "汇众SH6530G4\n",
      "汉兰达\n",
      "汉兰达（进口）\n",
      "汉腾X5\n",
      "汉腾X7\n",
      "汉风\n",
      "江南T11\n",
      "江南TT\n",
      "江淮K3\n",
      "江淮K5\n",
      "江淮iEV\n",
      "江淮iEV6E\n",
      "江淮iEV6S\n",
      "江淮俊铃\n",
      "江淮客车HFC\n",
      "江淮客车HK\n",
      "江淮康玲\n",
      "江淮瑞玲皮卡\n",
      "江淮瑞驰5R3\n",
      "江玲顺达\n",
      "江铃E100\n",
      "江铃E160\n",
      "江铃E200\n",
      "江铃凯锐轻型厢式货车\n",
      "江铃域虎\n",
      "江铃考斯特\n",
      "沃尔沃C30\n",
      "沃尔沃S40\n",
      "沃尔沃S60\n",
      "沃尔沃S60L\n",
      "沃尔沃S80\n",
      "沃尔沃S80L\n",
      "沃尔沃S90\n",
      "沃尔沃V40\n",
      "沃尔沃V60\n",
      "沃尔沃V90\n",
      "沃尔沃XC60\n",
      "沃尔沃XC90\n",
      "油罐车\n",
      "法拉利 458\n",
      "派力奥\n",
      "派喜\n",
      "派朗\n",
      "浪迪\n",
      "海域\n",
      "海星\n",
      "海星A9\n",
      "海星T22\n",
      "海景\n",
      "海格\n",
      "海格H5C\n",
      "海格H6V\n",
      "海狮\n",
      "海狮X30L\n",
      "海福星\n",
      "海迅\n",
      "海锋\n",
      "海马3\n",
      "海马M3\n",
      "海马M6\n",
      "海马M8\n",
      "海马S5\n",
      "海马S5青春版\n",
      "海马S7\n",
      "海马V70\n",
      "海马爱尚\n",
      "海马爱尚EV\n",
      "海马王子\n",
      "海马骑士\n",
      "混凝土搅拌车\n",
      "炫丽\n",
      "焕驰\n",
      "熊猫\n",
      "燃油助力\n",
      "爱丽舍\n",
      "爱唯欧\n",
      "爱腾\n",
      "爱迪尔\n",
      "牧马人\n",
      "牵引车\n",
      "特商牌\n",
      "特拉卡\n",
      "特殊结构重型卡车\n",
      "特顺\n",
      "狮跑\n",
      "猎豹6481\n",
      "猎豹CS10\n",
      "猎豹CS6\n",
      "猎豹CS7\n",
      "猎豹CS9\n",
      "猎豹CS9新能源\n",
      "猎豹CT7\n",
      "猎豹Q6\n",
      "玉虎\n",
      "王牌自卸车\n",
      "王牌轻卡\n",
      "玛驰\n",
      "现代i30\n",
      "现代ix25\n",
      "现代ix35\n",
      "理念S1\n",
      "瑞奕\n",
      "瑞宝\n",
      "瑞沃\n",
      "瑞纳\n",
      "瑞虎\n",
      "瑞虎3\n",
      "瑞虎3x\n",
      "瑞虎3xe\n",
      "瑞虎5\n",
      "瑞虎5x\n",
      "瑞虎7\n",
      "瑞虎8\n",
      "瑞迈\n",
      "瑞逸\n",
      "瑞铃\n",
      "瑞风\n",
      "瑞风A60\n",
      "瑞风M2\n",
      "瑞风M3\n",
      "瑞风M4\n",
      "瑞风M5\n",
      "瑞风M6\n",
      "瑞风S2\n",
      "瑞风S2mini\n",
      "瑞风S3\n",
      "瑞风S5\n",
      "瑞风S7\n",
      "瑞风Ⅱ\n",
      "瑞驰\n",
      "瑞鹰\n",
      "瑞麒G3\n",
      "瑞麒G5\n",
      "瑞麒G6\n",
      "瑞麒M1\n",
      "瑞麒M5\n",
      "瑞麒X1\n",
      "甲壳虫\n",
      "电动代步车\n",
      "电牛\n",
      "的士头多用途货车\n",
      "皇冠\n",
      "皮卡\n",
      "皮卡汽车\n",
      "睿翼\n",
      "睿行\n",
      "睿行M70\n",
      "睿行S50\n",
      "睿行S50T\n",
      "睿骋\n",
      "睿骋CC\n",
      "知豆\n",
      "知豆D1\n",
      "知豆D2\n",
      "神行者2\n",
      "神骐F30\n",
      "神骐T20\n",
      "祥锐\n",
      "祺智PHEV\n",
      "福仕达荣达\n",
      "福仕达鸿达\n",
      "福克斯\n",
      "福克斯（进口）\n",
      "福家\n",
      "福星卡自卸\n",
      "福瑞卡\n",
      "福瑞达\n",
      "福瑞达K22\n",
      "福瑞迪\n",
      "福田时代箱货\n",
      "福田瑞沃\n",
      "福睿斯\n",
      "福美来\n",
      "福美来M5\n",
      "福美来MPV\n",
      "福运\n",
      "福运来\n",
      "秀尔\n",
      "科帕奇\n",
      "科帕奇（进口）\n",
      "科沃兹\n",
      "科雷傲\n",
      "科雷嘉\n",
      "科鲁兹\n",
      "秦\n",
      "竞瑞\n",
      "粉粒物料运输车\n",
      "精灵\n",
      "索兰托\n",
      "索纳塔\n",
      "索纳塔九\n",
      "索纳塔八\n",
      "红岩牌\n",
      "红岩金刚\n",
      "红旗H7\n",
      "红旗盛世\n",
      "红星HX-5028新能源物流车\n",
      "纬度\n",
      "纯电动轻型客车\n",
      "纳5\n",
      "绅宝CC\n",
      "绅宝D20\n",
      "绅宝D50\n",
      "绅宝D60\n",
      "绅宝D70\n",
      "绅宝X25\n",
      "绅宝X35\n",
      "绅宝X55\n",
      "绅宝X65\n",
      "经典全顺\n",
      "经典帝豪\n",
      "维特拉\n",
      "缤智\n",
      "美人豹\n",
      "羚羊\n",
      "翱龙CUV\n",
      "翼搏\n",
      "翼神\n",
      "翼虎\n",
      "考斯特\n",
      "聚宝\n",
      "腾翼\n",
      "自卸\n",
      "自卸货车\n",
      "自卸车\n",
      "自由侠\n",
      "自由光\n",
      "自由光（进口）\n",
      "自由客\n",
      "自由舰\n",
      "自由风\n",
      "致悦\n",
      "致胜\n",
      "航天灵动\n",
      "艾力绅\n",
      "艾瑞泽3\n",
      "艾瑞泽5\n",
      "艾瑞泽5e\n",
      "艾瑞泽7\n",
      "艾瑞泽7e\n",
      "艾瑞泽M7\n",
      "芝麻\n",
      "花冠\n",
      "苏州金龙\n",
      "英伦C5\n",
      "英伦TX4\n",
      "英朗\n",
      "英致727\n",
      "英致737\n",
      "英致G3\n",
      "英菲尼迪ESQ\n",
      "英菲尼迪EX\n",
      "英菲尼迪FX\n",
      "英菲尼迪G\n",
      "英菲尼迪JX\n",
      "英菲尼迪M\n",
      "英菲尼迪Q50\n",
      "英菲尼迪Q50L\n",
      "英菲尼迪Q70\n",
      "英菲尼迪QX\n",
      "英菲尼迪QX30\n",
      "英菲尼迪QX50\n",
      "英菲尼迪QX60\n",
      "英速亚\n",
      "荣威350\n",
      "荣威360\n",
      "荣威550\n",
      "荣威750\n",
      "荣威950\n",
      "荣威Ei5\n",
      "荣威RX3\n",
      "荣威RX5\n",
      "荣威RX5新能源\n",
      "荣威RX8\n",
      "荣威W5\n",
      "荣威e550\n",
      "荣威e950\n",
      "荣威ei6\n",
      "荣威i6\n",
      "莲花L3\n",
      "莲花L5\n",
      "莲花竞悦\n",
      "莲花竞速\n",
      "菱俐\n",
      "菱帅\n",
      "菱智\n",
      "菲亚特500\n",
      "菲翔\n",
      "菲跃\n",
      "萨普\n",
      "萨瓦纳\n",
      "蒂阿兹\n",
      "蒙派克E\n",
      "蒙派克S\n",
      "蒙迪欧\n",
      "蒙迪欧致胜\n",
      "蓝瑟\n",
      "蓝鸟\n",
      "蔚揽\n",
      "蔚领\n",
      "虎V\n",
      "虎v-h\n",
      "西玛\n",
      "西耶那\n",
      "观致3\n",
      "观致5\n",
      "解放\n",
      "解放9米6货车\n",
      "解放J5K骏威\n",
      "解放J6\n",
      "解放J6L\n",
      "解放J6M\n",
      "解放J6P\n",
      "解放T80\n",
      "讴歌CDX\n",
      "讴歌MDX\n",
      "讴歌RDX\n",
      "讴歌RL\n",
      "讴歌TL\n",
      "讴歌TLX\n",
      "谷神\n",
      "豪华客车\n",
      "豪情SUV\n",
      "豪沃\n",
      "豪沃T7440\n",
      "豪沃斯太尔\n",
      "豪瀚\n",
      "财运100\n",
      "财运300\n",
      "货车\n",
      "货车系\n",
      "赛弗\n",
      "赛拉图\n",
      "赛欧\n",
      "赛豹\n",
      "赛铃\n",
      "赛飞利\n",
      "赛马\n",
      "起亚K2\n",
      "起亚K3\n",
      "起亚K3S\n",
      "起亚K4\n",
      "起亚K5\n",
      "起亚K5（进口）\n",
      "起亚KX3\n",
      "起亚KX5\n",
      "起亚KX7\n",
      "超级维特拉\n",
      "超龙\n",
      "超龙校车\n",
      "跃进\n",
      "跃进小福星\n",
      "跃进货车\n",
      "跃进轻卡\n",
      "跨越王\n",
      "路宝\n",
      "路尊大霸王\n",
      "路帝\n",
      "路盛E70\n",
      "路虎发现\n",
      "轩朗\n",
      "轩逸\n",
      "轮式装载机\n",
      "轻卡\n",
      "轻卡厢式货车\n",
      "轻型厢式货车\n",
      "轻型载货汽车\n",
      "载货汽车\n",
      "载重汽车\n",
      "辉昂\n",
      "辉腾\n",
      "迈威\n",
      "迈巴赫S级\n",
      "迈特威\n",
      "迈腾\n",
      "迈腾（进口）\n",
      "迈锐宝\n",
      "迈锐宝XL\n",
      "远景\n",
      "远景S1\n",
      "远景SUV\n",
      "远景X1\n",
      "远景X3\n",
      "迷迪\n",
      "逍客\n",
      "途乐\n",
      "途安\n",
      "途尊\n",
      "途昂\n",
      "途睿欧\n",
      "途胜\n",
      "途腾T1\n",
      "途观\n",
      "途观L\n",
      "途达\n",
      "途锐\n",
      "速尊\n",
      "速派\n",
      "速腾\n",
      "速锐\n",
      "逸动\n",
      "逸动DT\n",
      "逸动新能源\n",
      "逸致\n",
      "郑州日产俊风\n",
      "都市骏马\n",
      "都灵\n",
      "酷威\n",
      "酷搏\n",
      "酷熊\n",
      "重卡\n",
      "重型\n",
      "重型半挂牵引车\n",
      "重型普通货车\n",
      "重型自卸货车\n",
      "重型货车\n",
      "重汽商务LNG汽车\n",
      "重汽杭发\n",
      "重汽王牌轻卡\n",
      "野马F10\n",
      "野马F12\n",
      "野马F16\n",
      "野马F99\n",
      "野马T70\n",
      "野马T80\n",
      "金刚\n",
      "金刚财富\n",
      "金威\n",
      "金旅\n",
      "金旅海狮\n",
      "金杯750\n",
      "金杯F50\n",
      "金杯S50\n",
      "金杯S70\n",
      "金杯T30\n",
      "金杯T32\n",
      "金杯大海狮\n",
      "金杯快运\n",
      "金杯旗云\n",
      "金杯海狮\n",
      "金牌农家福\n",
      "金牛座\n",
      "金牛星\n",
      "金运卡\n",
      "金迪尔\n",
      "金鹰\n",
      "金龙\n",
      "钻卡\n",
      "铂锐\n",
      "锋范\n",
      "锋范经典\n",
      "锋驭\n",
      "锐3\n",
      "锐志\n",
      "锐欧\n",
      "锐界\n",
      "锐界（进口）\n",
      "锐腾\n",
      "锐行\n",
      "锐骐多功能车\n",
      "锐骐皮卡\n",
      "长城C20R\n",
      "长城C30\n",
      "长城C50\n",
      "长城M1\n",
      "长城M2\n",
      "长城M4\n",
      "长城V80\n",
      "长安4500\n",
      "长安CM8\n",
      "长安CS15\n",
      "长安CS35\n",
      "长安CS55\n",
      "长安CS75\n",
      "长安CS95\n",
      "长安CX20\n",
      "长安CX30\n",
      "长安CX70\n",
      "长安SC5027XXYDA4\n",
      "长安之星\n",
      "长安之星2\n",
      "长安之星3\n",
      "长安之星7\n",
      "长安之星9\n",
      "长安之星S460\n",
      "长安新豹\n",
      "长安星光\n",
      "长安星卡\n",
      "长安欧尚A800\n",
      "长安轻型厢式货车\n",
      "长春一汽J6M\n",
      "阁瑞斯\n",
      "阅朗\n",
      "阳光\n",
      "阿特兹\n",
      "陆铃\n",
      "陆铃皮卡\n",
      "陆风X2\n",
      "陆风X5\n",
      "陆风X6\n",
      "陆风X7\n",
      "陆风X8\n",
      "陆风X9\n",
      "陕汽德龙\n",
      "陕汽德龙3000\n",
      "陕汽德龙F3000\n",
      "陕汽德龙f3000\n",
      "陕汽德龙新M3000\n",
      "陕汽德龙新m3000\n",
      "陕汽牌\n",
      "陕汽通家福家\n",
      "雄师F22\n",
      "雄狮\n",
      "雅力士\n",
      "雅尊\n",
      "雅特\n",
      "雅特GTC\n",
      "雅科仕\n",
      "雅绅特\n",
      "雅阁\n",
      "雨燕\n",
      "雪铁龙C2\n",
      "雪铁龙C3-XR\n",
      "雪铁龙C4 Aircross\n",
      "雪铁龙C4L\n",
      "雪铁龙C5\n",
      "雪铁龙C6\n",
      "雷克萨斯CT\n",
      "雷克萨斯ES\n",
      "雷克萨斯GS\n",
      "雷克萨斯GX\n",
      "雷克萨斯IS\n",
      "雷克萨斯LS\n",
      "雷克萨斯LX\n",
      "雷克萨斯NX\n",
      "雷克萨斯RX\n",
      "雷凌\n",
      "雷斯特\n",
      "雷龙\n",
      "霸锐\n",
      "青岛产\n",
      "顺达\n",
      "领主\n",
      "领克01\n",
      "领动\n",
      "领翔\n",
      "领航员\n",
      "领驭\n",
      "领驰490\n",
      "领骐\n",
      "颐达\n",
      "风云2\n",
      "风光\n",
      "风光330\n",
      "风光360\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "风光370\n",
      "风光580\n",
      "风光S560\n",
      "风华\n",
      "风尚\n",
      "风度MX5\n",
      "风度MX6\n",
      "风景\n",
      "风景G7\n",
      "风景G9\n",
      "风景V3\n",
      "风朗\n",
      "风神A30\n",
      "风神A60\n",
      "风神AX3\n",
      "风神AX4\n",
      "风神AX5\n",
      "风神AX7\n",
      "风神H30\n",
      "风神L60\n",
      "风神S30\n",
      "风行CM7\n",
      "风行F600\n",
      "风行S500\n",
      "风行SX6\n",
      "风迪思\n",
      "风骏3\n",
      "风骏5\n",
      "风骏6\n",
      "飞度\n",
      "飞思\n",
      "飞碟汽车\n",
      "飞腾\n",
      "飞越\n",
      "飞驰\n",
      "马自达 ATENZA\n",
      "马自达2\n",
      "马自达2劲翔\n",
      "马自达3\n",
      "马自达3 昂克赛拉\n",
      "马自达323\n",
      "马自达3星骋\n",
      "马自达3（进口）\n",
      "马自达5\n",
      "马自达6\n",
      "马自达8\n",
      "马自达CX-4\n",
      "马自达CX-5\n",
      "马自达CX-7\n",
      "马自达CX-7（进口）\n",
      "马自达MX-5\n",
      "驭胜S330\n",
      "驭胜S350\n",
      "驰鹏\n",
      "骁途\n",
      "骊威\n",
      "骏威\n",
      "骏意\n",
      "骏捷\n",
      "骏捷Wagon\n",
      "骏派A50\n",
      "骏派A70\n",
      "骏派CX65\n",
      "骏派D60\n",
      "骏玲\n",
      "骏逸\n",
      "骏铃\n",
      "骏铃G340Y\n",
      "骏领\n",
      "骐菱\n",
      "骐达\n",
      "骐铃T5\n",
      "骐铃T7\n",
      "骑士S12\n",
      "高尔夫\n",
      "高尔夫·嘉旅\n",
      "高尔夫（进口）\n",
      "麦柯斯\n",
      "黄海N1\n",
      "黄海N2\n",
      "黄海N3\n",
      "黑金刚\n",
      "龙V\n"
     ]
    }
   ],
   "source": [
    "result=pd.DataFrame(columns=['品牌','问题','数量'])\n",
    "for name,group in car_complain.groupby('car_big'):\n",
    "    print(name)\n",
    "    dict1={}\n",
    "    for a,b in group.iterrows():\n",
    "        \n",
    "        i=0\n",
    "        count=len(b['question'].split(','))\n",
    "        while (2*i+1)<count:\n",
    "            #print(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1])\n",
    "            if dict1.__contains__(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]):\n",
    "                dict1[b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]] = dict1.get(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1])+1\n",
    "            else:\n",
    "                dict1[b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]] = 1\n",
    "            \n",
    "            #print(b['question'].split(',')[2*i])\n",
    "            #print(b['question'].split(',')[2*i+1])\n",
    "            i = i+1\n",
    "    #print(dict1)\n",
    "    #dict1.values\n",
    "    temp = pd.DataFrame(list(dict1.items()),columns=['问题','数量'])\n",
    "    temp['品牌'] = name\n",
    "    result = result.append(temp)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "379"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result[result['品牌']=='朗逸']['数量']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "lyresult = result[result['品牌']=='朗逸']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "top10 = lyresult[lyresult['数量']>60]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "top10.to_csv('投诉.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2.0L 自动 品雅\n",
      "2008款 1.4T DSG 运动版\n",
      "2008款 1.6 手动 品悠版\n",
      "2008款 1.6 手动 品轩版\n",
      "2008款 1.6 手动 品雅版\n",
      "2008款 1.6 手动 品雅版(带选装)\n",
      "2008款 1.6 自动 品悠版\n",
      "2008款 1.6 自动 品轩版\n",
      "2008款 1.6 自动 品雅版\n",
      "2008款 1.6 自动 品雅版(带选装)\n",
      "2008款 2.0 手动 品雅版\n",
      "2008款 2.0 自动 品尊版\n",
      "2008款 2.0 自动 品轩版\n",
      "2009款 2.0 手动 品悠版\n",
      "2009款 2.0 自动 品悠版\n",
      "2010款 1.6 手动 品悠版（进享型）\n",
      "2010款 1.6 手动 品雅版（进享型）\n",
      "2010款 1.6 自动 品轩版（进享型）\n",
      "2010款 1.6 自动 品雅版（进享型）\n",
      "2011款 1.4TSI DSG 品雅版\n",
      "2011款 1.4TSI DSG品轩版\n",
      "2011款 1.4TSI DSG运动版\n",
      "2011款 1.4TSI 手动 品轩版\n",
      "2011款 1.4TSI 手动 品雅版\n",
      "2011款 1.6 手动 品悠版\n",
      "2011款 1.6 手动 品雅版\n",
      "2011款 1.6 自动 品悠版\n",
      "2011款 1.6 自动 品轩版\n",
      "2011款 1.6 自动 品雅版\n",
      "2011款 2.0 手动 品悠版\n",
      "2011款 2.0 自动 品悠版\n",
      "2013款 1.4TSI DSG舒适版\n",
      "2013款 1.4TSI DSG舒适版 改款\n",
      "2013款 1.4TSI DSG豪华导航版\n",
      "2013款 1.4TSI DSG豪华版\n",
      "2013款 1.4TSI DSG豪华版 改款\n",
      "2013款 1.4TSI 手动 舒适版\n",
      "2013款 1.4TSI 手动 舒适版 改款\n",
      "2013款 1.4TSI 手动 豪华版\n",
      "2013款 1.6L 手动 经典风尚版\n",
      "2013款 1.6L 手动 舒适版\n",
      "2013款 1.6L 手动 舒适版 改款\n",
      "2013款 1.6L 手动 风尚版\n",
      "2013款 1.6L 手动 风尚版 改款\n",
      "2013款 1.6L 自动 经典风尚版\n",
      "2013款 1.6L 自动 舒适版\n",
      "2013款 1.6L 自动 舒适版 改款\n",
      "2013款 1.6L 自动 豪华版\n",
      "2013款 1.6L 自动 风尚版\n",
      "2013款 1.6L 自动 风尚版 改款\n",
      "2014款 1.4TSI DSG30周年纪念版\n",
      "2014款 1.4TSI DSG蓝驱技术版\n",
      "2014款 1.4TSI DSG运动版\n",
      "2014款 1.6L 自动运动版\n",
      "2015款 1.6 手动 舒适版\n",
      "2015款 1.6L 手动 风尚版\n",
      "2015款 1.6L 自动 舒适版\n",
      "2015款 1.6L 自动 风尚版\n",
      "2015款 230TSI DSG舒适版\n",
      "2015款 230TSI DSG豪华版\n",
      "2015款 230TSI 手动 舒适版\n",
      "2015款 230TSI 手动 豪华版\n",
      "2016款 280TSI DSG运动版\n",
      "2017款 1.6L 手动 舒适版\n",
      "2017款 1.6L 手动 风尚版\n",
      "2017款 1.6L 自动 舒适版\n",
      "2017款 1.6L 自动 风尚版\n",
      "2017款 180TSI 双离合 舒适版\n",
      "2017款 230TSI 双离合 舒适版\n",
      "2018款 1.5L 自动 舒适版\n",
      "2018款 280TSI DSG 舒适版\n",
      "世博版1.6 AT\n",
      "无\n",
      "朗逸SVW7167NSD\n"
     ]
    }
   ],
   "source": [
    "result=pd.DataFrame(columns=['品牌','问题','数量'])\n",
    "for name,group in ly.groupby('car_small'):\n",
    "    print(name)\n",
    "    dict1={}\n",
    "    for a,b in group.iterrows():\n",
    "        \n",
    "        i=0\n",
    "        count=len(b['question'].split(','))\n",
    "        while (2*i+1)<count:\n",
    "            #print(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1])\n",
    "            if dict1.__contains__(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]):\n",
    "                dict1[b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]] = dict1.get(b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1])+1\n",
    "            else:\n",
    "                dict1[b['question'].split(',')[2*i]+','+b['question'].split(',')[2*i+1]] = 1\n",
    "            \n",
    "            #print(b['question'].split(',')[2*i])\n",
    "            #print(b['question'].split(',')[2*i+1])\n",
    "            i = i+1\n",
    "    #print(dict1)\n",
    "    #dict1.values\n",
    "    temp = pd.DataFrame(list(dict1.items()),columns=['问题','数量'])\n",
    "    temp['品牌'] = name\n",
    "    result = result.append(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = result.groupby(['品牌'])['数量'].count().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "top10 = temp[temp['数量']>40]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "top10.to_csv('年款_投诉.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>品牌</th>\n",
       "      <th>数量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.0L 自动 品雅</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2008款 1.4T DSG 运动版</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2008款 1.6 手动 品悠版</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2008款 1.6 手动 品轩版</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2008款 1.6 手动 品雅版</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2008款 1.6 手动 品雅版(带选装)</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2008款 1.6 自动 品悠版</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2008款 1.6 自动 品轩版</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2008款 1.6 自动 品雅版</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2008款 1.6 自动 品雅版(带选装)</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2008款 2.0 手动 品雅版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2008款 2.0 自动 品尊版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2008款 2.0 自动 品轩版</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2009款 2.0 手动 品悠版</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2009款 2.0 自动 品悠版</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2010款 1.6 手动 品悠版（进享型）</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2010款 1.6 手动 品雅版（进享型）</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2010款 1.6 自动 品轩版（进享型）</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2010款 1.6 自动 品雅版（进享型）</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2011款 1.4TSI DSG 品雅版</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2011款 1.4TSI DSG品轩版</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2011款 1.4TSI DSG运动版</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2011款 1.4TSI 手动 品轩版</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2011款 1.4TSI 手动 品雅版</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2011款 1.6 手动 品悠版</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2011款 1.6 手动 品雅版</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2011款 1.6 自动 品悠版</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2011款 1.6 自动 品轩版</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2011款 1.6 自动 品雅版</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2011款 2.0 手动 品悠版</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2013款 1.6L 自动 经典风尚版</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2013款 1.6L 自动 舒适版</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2013款 1.6L 自动 舒适版 改款</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2013款 1.6L 自动 豪华版</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2013款 1.6L 自动 风尚版</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2013款 1.6L 自动 风尚版 改款</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2014款 1.4TSI DSG30周年纪念版</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2014款 1.4TSI DSG蓝驱技术版</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2014款 1.4TSI DSG运动版</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2014款 1.6L 自动运动版</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2015款 1.6 手动 舒适版</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2015款 1.6L 手动 风尚版</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2015款 1.6L 自动 舒适版</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2015款 1.6L 自动 风尚版</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2015款 230TSI DSG舒适版</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2015款 230TSI DSG豪华版</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2015款 230TSI 手动 舒适版</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2015款 230TSI 手动 豪华版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2016款 280TSI DSG运动版</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2017款 1.6L 手动 舒适版</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2017款 1.6L 手动 风尚版</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2017款 1.6L 自动 舒适版</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2017款 1.6L 自动 风尚版</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2017款 180TSI 双离合 舒适版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2017款 230TSI 双离合 舒适版</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2018款 1.5L 自动 舒适版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2018款 280TSI DSG 舒适版</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>世博版1.6 AT</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>无</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>朗逸SVW7167NSD</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>74 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         品牌  数量\n",
       "0                2.0L 自动 品雅   1\n",
       "1        2008款 1.4T DSG 运动版  27\n",
       "2          2008款 1.6 手动 品悠版   9\n",
       "3          2008款 1.6 手动 品轩版   7\n",
       "4          2008款 1.6 手动 品雅版  14\n",
       "5     2008款 1.6 手动 品雅版(带选装)   3\n",
       "6          2008款 1.6 自动 品悠版  12\n",
       "7          2008款 1.6 自动 品轩版  19\n",
       "8          2008款 1.6 自动 品雅版  18\n",
       "9     2008款 1.6 自动 品雅版(带选装)   2\n",
       "10         2008款 2.0 手动 品雅版   1\n",
       "11         2008款 2.0 自动 品尊版   1\n",
       "12         2008款 2.0 自动 品轩版   5\n",
       "13         2009款 2.0 手动 品悠版   2\n",
       "14         2009款 2.0 自动 品悠版  14\n",
       "15    2010款 1.6 手动 品悠版（进享型）  10\n",
       "16    2010款 1.6 手动 品雅版（进享型）  21\n",
       "17    2010款 1.6 自动 品轩版（进享型）  14\n",
       "18    2010款 1.6 自动 品雅版（进享型）  21\n",
       "19     2011款 1.4TSI DSG 品雅版  39\n",
       "20      2011款 1.4TSI DSG品轩版  33\n",
       "21      2011款 1.4TSI DSG运动版  33\n",
       "22      2011款 1.4TSI 手动 品轩版  13\n",
       "23      2011款 1.4TSI 手动 品雅版  18\n",
       "24         2011款 1.6 手动 品悠版  33\n",
       "25         2011款 1.6 手动 品雅版  34\n",
       "26         2011款 1.6 自动 品悠版  18\n",
       "27         2011款 1.6 自动 品轩版  13\n",
       "28         2011款 1.6 自动 品雅版  43\n",
       "29         2011款 2.0 手动 品悠版  10\n",
       "..                      ...  ..\n",
       "44      2013款 1.6L 自动 经典风尚版  12\n",
       "45        2013款 1.6L 自动 舒适版  76\n",
       "46     2013款 1.6L 自动 舒适版 改款  27\n",
       "47        2013款 1.6L 自动 豪华版  34\n",
       "48        2013款 1.6L 自动 风尚版  48\n",
       "49     2013款 1.6L 自动 风尚版 改款  14\n",
       "50  2014款 1.4TSI DSG30周年纪念版   4\n",
       "51    2014款 1.4TSI DSG蓝驱技术版  13\n",
       "52      2014款 1.4TSI DSG运动版   9\n",
       "53         2014款 1.6L 自动运动版   7\n",
       "54         2015款 1.6 手动 舒适版  42\n",
       "55        2015款 1.6L 手动 风尚版  38\n",
       "56        2015款 1.6L 自动 舒适版  59\n",
       "57        2015款 1.6L 自动 风尚版  43\n",
       "58      2015款 230TSI DSG舒适版  27\n",
       "59      2015款 230TSI DSG豪华版   2\n",
       "60      2015款 230TSI 手动 舒适版   7\n",
       "61      2015款 230TSI 手动 豪华版   1\n",
       "62      2016款 280TSI DSG运动版   7\n",
       "63        2017款 1.6L 手动 舒适版  16\n",
       "64        2017款 1.6L 手动 风尚版  21\n",
       "65        2017款 1.6L 自动 舒适版  48\n",
       "66        2017款 1.6L 自动 风尚版  25\n",
       "67     2017款 180TSI 双离合 舒适版   1\n",
       "68     2017款 230TSI 双离合 舒适版  23\n",
       "69        2018款 1.5L 自动 舒适版   1\n",
       "70     2018款 280TSI DSG 舒适版   1\n",
       "71                世博版1.6 AT   2\n",
       "72                        无   1\n",
       "73             朗逸SVW7167NSD   5\n",
       "\n",
       "[74 rows x 2 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
